About

Amit Kumar Rout is a Senior Member Technical at ADP with over 5 years of experience in IT, specializing in Database Design, Development, and Support of MS SQL Server 2012/2014. He is proficient in Relational Database Management Systems (RDBMS), and has expertise in T-SQL (DDL, DML, DCL) and in Design and Normalization of database tables. Amit has experience in implementing business logic using Triggers, Indexes, Views, and Stored Procedures, and is skilled in tools like SQL Server Management Studio (SSMS) and SQL Server Integration (SSIS). He is proficient in tuning T-SQL queries to improve database performance and availability, and has experience in creating and updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance. Amit is also an expert in creating Packages using SQL Server Integration Services (SSIS). Amit has excellent analytical, communication, and interpersonal skills, and is proficient in technical writing and presentations. He is a good team player and has experience working in a team environment. Prior to joining ADP, Amit worked as a Site Engineer at Power Grid, where he was involved in creating Entity Relationship (ER) Diagrams to the proposed database, creating database objects such as tables, views, stored procedures, Triggers, and functions, and developing SQL scripts, indexes, and complex queries. He was also responsible for preparing reports, day-to-day management of the site, including supervising and monitoring the site labour force and the work of any subcontractors, planning the work and efficiently organizing site facilities in order to meet agreed deadlines, overseeing quality control and health and safety matters on site, and resolving any unexpected technical difficulties and other problems that may arise. Amit also worked as an SQL Developer at Cybage, where he was responsible for developing SSIS packages for ETL of feeds from different heterogeneous systems and load the data in Data warehouse. He was also responsible for writing complex SQL queries to achieve the requirements, writing stored procedures and functions, monitoring the daily runs and status in different Environment, identifying, analyzing, and fixing issues, if encountered during runs, developing codes to maximize the automation of the process, scheduling SSIS packages using SSMS, developing slowly changing dimensions (SCD) and Change Data Capture (CDC), and providing Production support to the client on a 24*7 basis. Amit holds a Bachelor of Technology degree in Electrical, Electronics, and Communications Engineering from Bal